ODBC Drivers

Additional Setup Information

The following topic discusses additional steps you must perform to set up the ODBC Drivers.

Additional Setup Information

Driver Information

The following topics discuss the ODBC Drivers.

Btrieve Driver

dBASE Driver

Microsoft Access Driver

Microsoft Excel Driver

Microsoft FoxPro Driver

ORACLE6 Driver

ORACLE7 Driver

Paradox Driver

SQL Server Driver

Text Driver


Additional Setup Information

The following drivers require additional setup steps or additional software components. All other drivers only require that you install them from disk and, depending on your application, add one or more data sources for the driver.

Btrieve Driver

The Btrieve driver requires the WBTRCALL.DLL dynamic link library (DLL), which is available from Novell, Inc. or your local software dealer.

See Also

Btrieve for Windows DLL

dBASE Driver

Before you use the dBASE driver, you must place the following line in your AUTOEXEC.BAT file:

SHARE /L:200

The SHARE command allows file sharing and locking in a multitasking environment.  The /L option specifies the number of files that can be locked at one time.

Microsoft Access Driver

If you do not have Microsoft Access installed on your computer, add the following line to your CONFIG.SYS file:

FILES= 50

and the following line to your AUTOEXEC.BAT file:

SHARE.EXE /L:200

(If you are working with very large databases, this should be SHARE.EXE /L:500.)

Microsoft FoxPro Driver

Before you use the Microsoft FoxPro driver, you must place the following line in your AUTOEXEC.BAT file:

SHARE /L:200

The SHARE command allows file sharing and locking in a multitasking environment.  The /L option specifies the number of files that can be locked at one time.

ORACLE Driver

Client Requirements

The ORACLE drivers require Oracle SQL*Net for Windows V1 or V2 client network software to communicate across a network with ORACLE Server.  If you have not already done so, install these on your computer.

Oracle SQL*Net must be installed prior to installing the Oracle7 ODBC driver because the ODBC driver is dependent on ORA7WIN.DLL. Make sure that c:\orawin\bin is in your path where orawin is your default Oracle home for your Oracle Windows products.

Server Requirements

The Oracle drivers require networking protocol software supported by Oracle SQL*Net for Windows (such as TCP/IP or SPX/IPX).

Upgrading Data Source from Oracle 6 to Oracle7

The Oracle7 ODBC driver supports only the Oracle7 server. Likewise, the Oracle6 ODBC driver supports only the Oracle6 server. (The Oracle7 driver is not compatible with the Oracle6 driver.) If you have upgraded to the Oracle7 server, you must reconfigure your data source to use the Oracle7 driver as follows:

1	From the Windows Control Panel, double-click the ODBC icon.

2	In the Data Sources dialog box, choose the Add button.

3	In the Add Data Source dialog box, select Oracle7 from the list.

4	In the Oracle7 ODBC Setup dialog box, enter information for the data source to be updated, and then choose OK. If needed, refer to your Oracle6 data source for the "SQL*Net Connect String."

5	In the Data Sources dialog box, select the Oracle6 data source from the list, and then choose Delete.

See Also

Hardware and Software Requirements for the ORACLE6 Driver

Hardware and Software Requirements for the ORACLE7 Driver

Setting Up the ORACLE6 Driver

Setting Up the ORACLE7 Driver

SQL Server Driver

The SQL Server driver uses the Net-Library DLLs to communicate across a network with SQL Server.  If you have not already done so, install these on your computer.

It also uses the catalog stored procedures, which must be installed on your copy of SQL Server.  The catalog stored procedures are automatically installed on later versions of Microsoft SQL Server.

See Also

Hardware and Software Requirements for the SQL Server Driver

Setting Up the SQL Server Driver

Installing the Catalog Stored Procedures